SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001654s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012431 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012431 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (677018,714639,606286,1048409,408329,524729,190317,841310,519996,439695,668981,769970,1023214,979455,754381,374083,873903,40812,169643,1018281,662824,842923,1012476,2540,241840,95637,510480,609771,782861,1045823,441462,399254,750477,724035,548136,747521,549552,173815,198597,291642,834018,306270,181427,273218,217157,819064,157515,240279,514203,465201,231855,39228,196765,1040594,316803,925069,183521,836168,531364,623299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012431 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012431 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]