SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009208 LIMIT 1 [ RunTime:0.000462s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009208 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7814,872212,801318,78298,543687,531305,601833,915513,436381,452542,454551,728415,490624,559106,1007220,788951,33788,191095,672377,871873,341697,322644,60085,166635,268075,332737,761415,408380,419192,418784,606860,776836,365554,927014,250598,903646,612847,295301,1040057,378546,895384,1027155,55515,225889,967965,714395,513364,1031732,802785,149908,442647,325169,178143,587023,404697,42172,445129,588142,658501,566489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000607s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]