SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445781 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445781 [ RunTime:0.001937s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829244,160229,604502,851436,945426,748439,305945,162685,174351,723123,53448,27269,940084,52725,220429,234117,746295,395178,726975,599248,272988,82324,1042546,45880,237125,998970,815191,637384,23425,950492,1017725,601394,612565,916236,72253,513719,745474,860150,798554,690687,809735,184637,114098,586399,204765,46842,984809,976519,969027,645019,640640,976995,775360,350696,624440,23384,387970,129802,703672,712497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445781 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445781 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]