SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407457 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407457 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831038,335649,150371,1019594,271072,772793,406716,353366,731420,222159,246148,85839,21216,255025,641146,120457,752030,773328,982470,739606,558534,687754,428262,144051,423508,138732,390699,997118,351134,1735,23593,762173,920441,152561,266336,879755,508729,284710,868392,354735,644413,1004087,687978,629828,474323,207569,959212,779104,70535,807211,211817,94530,689823,329903,105258,582207,870778,1039735,549979,284949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000887s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407457 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407457 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]