SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48018 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48018 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (566388,204111,757043,1044413,472576,1023874,573787,561670,388092,42628,589260,64022,133838,923370,221184,724672,185470,839705,205467,196175,1031059,308772,762928,253389,523351,462450,571695,580329,578522,179530,762476,524552,701603,154309,935555,508506,694506,718326,873991,791527,826985,805913,458974,389638,1011220,608162,236564,222501,207565,806067,567425,779319,669239,26852,265336,719012,560480,833824,151627,735595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000975s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]