SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38311 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38311 [ RunTime:0.002295s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698843,796142,963526,753971,154468,1037383,309861,967840,230631,251263,477026,1013555,261993,1009023,1019901,955011,865063,1017619,939065,727371,599000,650977,552563,521996,1039556,351761,642429,1024569,582984,389943,913175,9863,68329,107572,14148,492159,627533,529986,937007,611140,651963,646422,46010,723703,952639,292753,999180,315630,751057,866097,105946,897552,274555,2727,882124,360296,546126,39463,311249,396391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]