SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002029s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 439324 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 439324 [ RunTime:0.003130s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774765,537880,606381,688231,481617,656448,712922,852402,509109,1043221,740359,474176,870498,904411,860123,815647,666229,339727,523803,518224,380490,520858,520243,586847,507967,662729,963994,721869,205441,812893,753352,85523,180685,938226,494355,1018489,131152,313652,722666,668602,412074,996434,421974,303313,775848,836869,705563,66829,311431,646563,903404,436752,949132,109950,504838,733560,118211,313331,193537,357966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 439324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 439324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]