SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446810 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446810 [ RunTime:0.002490s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540517,1010559,892748,618608,913884,1031635,736192,843569,487363,630127,921303,98260,463587,925704,408676,505422,447791,133894,734306,792422,140516,341367,646622,483544,70445,401709,769613,88279,69316,449423,722769,154068,823463,615448,560128,935462,139867,455996,235717,967738,272990,757305,442115,433864,971097,493383,717485,383519,843070,718483,164943,68807,549979,79487,855849,771942,966366,919684,758810,995663) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]