SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488791 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488791 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986801,144836,1026316,1046107,688847,542029,716872,856016,1032633,847032,421799,896086,60354,776313,138797,271617,587028,707879,923518,972593,495188,212602,157116,127325,121528,941894,633402,1047873,765343,404655,797819,576081,265425,769866,312393,961623,214631,729984,934836,16044,504690,91366,663706,395629,137687,358193,675070,898575,282781,889099,255536,832917,616507,829356,593321,1002949,687143,231422,369636,1011489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]