SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001485s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 592926 LIMIT 1 [ RunTime:0.002704s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 592926 [ RunTime:0.002585s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482080,846943,98124,781410,152106,500678,966456,975189,616324,870120,206124,970040,565709,984725,386701,344148,189936,941943,356133,129696,533490,829906,544943,361672,35898,45769,324482,439334,283806,743417,232139,883580,701710,741394,214129,179268,933777,11026,62506,438655,187819,428691,745607,135372,885385,160048,572844,493101,950764,889625,605315,197776,972206,755167,584725,917424,767270,154169,907507,711201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001798s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 592926 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 592926 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002178s ]