SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048623 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048623 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (382644,552439,361171,86451,248426,822421,993328,374660,816444,728038,427766,125525,315720,435395,292554,1037547,887025,463760,411210,586305,804482,175305,45702,372760,819178,137478,568715,340229,975326,794562,606458,22348,286118,61025,546880,876576,974110,294809,696209,315612,306661,682321,806423,124977,473837,29536,954754,435610,988851,838774,391658,946482,1041081,295053,578963,915965,157109,552184,444485,1008131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048623 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048623 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]