SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981080 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981080 [ RunTime:0.002589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (324444,1040615,94917,89491,326389,212940,942305,397996,810908,869852,13831,255171,99601,154291,885219,1044064,689844,419982,984024,248958,1020389,32907,1036486,337837,207143,469143,383217,344083,316170,856721,190280,407585,1008536,395990,519877,833119,661395,340253,141556,250545,362395,887492,336890,619144,897204,978958,524920,772365,368409,870085,890756,547146,799168,801959,804884,481972,1038516,749044,52980,1008301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981080 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981080 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001917s ]