SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106710 LIMIT 1 [ RunTime:0.000682s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106710 [ RunTime:0.002851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (107993,230958,106044,14329,516794,616257,1005057,410373,375417,986779,83061,317338,577732,1046032,928745,510051,385040,968781,399956,72970,499353,1019643,922767,1024734,604646,291040,303923,1035337,477843,502322,755878,336265,216139,1411,119023,992423,884472,158053,271114,238138,149649,569109,746137,1005872,96224,356266,135256,1034950,9921,896786,801687,593205,495970,539186,420491,102859,933329,911734,653520,943246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]