SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106941 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106941 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (962496,567755,425824,494366,75686,622364,649141,158621,970247,421822,979243,995108,179704,103051,92929,242914,303785,432059,303623,172116,754497,623761,397115,520339,563281,66541,322929,531715,1031203,833457,482374,201660,91212,200026,442204,784006,913,397858,387971,853480,87054,881120,67559,611145,17189,1001288,675041,910220,1014432,1048234,535563,950743,764463,165735,502834,666917,377593,635972,269031,53122) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001969s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]