SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64212 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64212 [ RunTime:0.002217s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (960498,759793,343119,635751,349968,1043195,562776,718588,1035828,611376,699316,583069,777379,894590,965393,540584,649410,1016476,392896,380800,562228,652489,169581,398568,793991,327223,131031,625342,629311,629209,249170,855910,879950,181614,1029638,826370,680910,354625,429025,969663,422112,1029793,688169,639914,185858,633136,1030344,225454,759519,885799,480299,26339,6979,632713,161747,942781,547290,46048,676588,211336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64212 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64212 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]