SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 482994 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 482994 [ RunTime:0.002488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521065,817921,142311,839404,963160,139649,691470,651289,390378,507118,910444,614449,191639,834491,389932,692982,197370,918106,886213,1008902,300523,14332,558933,979646,776981,210280,213181,654483,291206,95787,726966,991872,592618,468559,718350,160651,427761,89730,490219,415724,205178,1014215,714935,307034,1007960,422776,575014,706491,155894,942990,176584,848817,219241,497874,349624,52434,301000,422573,338366,372471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 482994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 482994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]