SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 189610 LIMIT 1 [ RunTime:0.001023s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 189610 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121082,297120,153941,542375,197789,511869,511820,532364,833865,933223,257233,687865,747851,654688,700752,41743,137545,476835,963976,155652,240342,55520,402999,594519,813419,342501,468588,671005,874198,39327,908625,112302,207366,365112,862339,19298,110206,120072,601050,161863,47905,911654,301217,5720,36205,518350,916502,901093,214045,954932,622631,914208,997068,116776,484277,1039067,287489,47007,719268,728) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 189610 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 189610 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]