SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201242 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201242 [ RunTime:0.001926s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142393,294424,346704,395082,255481,432003,410647,476117,118729,75468,25579,542881,211673,1035678,521077,941076,978105,892534,664719,453135,893913,167903,754652,736003,59997,328378,924558,729117,721164,128271,510986,803460,677516,273627,938199,1014379,758343,1035856,871064,977342,69395,504625,598193,713177,720179,726579,430122,731595,352738,718837,3990,320690,563252,351432,1039507,515896,613848,476819,147233,916453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201242 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201242 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002597s ]