SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415847 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415847 [ RunTime:0.001683s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1047836,610340,1043902,260510,212994,100633,98140,474112,1042518,1045414,650473,135928,548125,463048,1015432,53778,839657,337045,838215,705976,268544,374419,388879,119763,818716,763429,982991,153353,481367,132937,36884,577756,626361,414868,678286,435067,673703,489742,866938,913982,683329,761784,149592,291481,1023970,286413,32784,243864,792709,1012476,141487,368772,367476,782134,434074,1749,1036202,1047615,979044,97329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415847 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415847 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]