SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484599 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484599 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746462,552530,68262,436012,229460,778387,428066,206309,398422,473215,311051,412188,254662,87087,358617,978455,829291,411737,243472,1010020,989285,532927,901744,525162,668389,933311,53292,582902,81979,189836,99469,135874,973868,484132,706090,706129,670911,596189,646508,657704,555485,710041,716036,604396,855333,1043358,223521,131778,1022968,665740,577009,6152,693713,678452,93484,664366,508918,1037578,721620,890808) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000652s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001492s ]