SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022579 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022579 [ RunTime:0.006194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788639,66547,253237,856535,1033143,64800,814950,19326,260265,252119,162516,333836,873548,1546,863636,879373,298240,709236,62000,13418,596949,990544,954871,139216,193508,106086,540315,303330,836225,456032,233892,566118,235081,143617,881814,221045,932156,545032,611411,33332,390945,75521,330358,422677,432438,481429,514397,461053,820525,129091,151403,491231,230927,548179,1029324,877048,113408,943066,611159,475179) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022579 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022579 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]