SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402854 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402854 [ RunTime:0.002257s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (133771,604078,599574,409207,27507,903611,688996,588060,425988,1027555,547527,495986,266794,933899,276289,220215,776752,1015062,648328,51584,67133,140674,1011408,326847,99992,491882,827205,251579,33971,677481,630873,1042122,246953,963558,357425,481400,329402,73450,21403,829692,250316,739313,599053,8289,974553,914028,163896,996710,807226,300720,440884,512501,391288,149335,312739,396584,265132,986999,430355,284948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]