SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001382s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471310 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471310 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177520,761152,955604,152866,905783,261632,960165,487169,520602,204969,659990,82445,42046,910674,117269,738756,399644,1004903,712914,322280,9961,445778,570268,302873,525695,63868,898599,908357,448073,154428,672601,670512,114043,762172,920623,458947,695518,774042,857775,616938,274027,166375,1034943,576531,270426,608234,15897,272394,356393,574183,22754,548453,805215,631944,90504,375687,168640,659353,596059,355002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471310 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471310 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000656s ]