SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543076 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543076 [ RunTime:0.001527s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (517610,36740,804944,217377,1042608,1007326,613152,667139,607779,789924,428097,773000,190706,789394,126326,732882,45891,977017,506630,982988,61791,455837,413456,684744,513594,1024649,136471,412685,402077,1011895,792467,627363,207048,779609,755941,852424,55316,64132,532259,973471,354451,1008733,825132,473781,35961,463150,536764,53890,825544,406957,934387,260360,996214,4169,427660,779212,686577,607554,311572,459291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543076 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543076 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]