SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420815 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420815 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005520,359229,1046482,296172,349495,489429,257517,660789,914053,334568,232639,126222,250951,1062,253042,797007,32411,107879,868685,240228,309822,486904,878740,133640,286965,295117,194702,118303,422847,123780,691394,755151,802399,973799,334133,441458,843384,552140,797934,190088,892573,48802,858101,763936,118760,12938,363830,748928,15454,618191,256053,435349,248245,1044061,606615,840735,304217,593394,517247,101834) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]