SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50625 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50625 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1029216,728850,104932,778247,928515,585812,347023,147329,658177,348845,120852,848340,241869,200976,473192,913927,125728,9051,139666,760288,220277,325496,200879,1039724,671935,835999,80558,303708,780627,752376,30572,28644,666967,794362,293764,114274,391133,620977,290443,238516,538610,309520,192302,548344,354553,339167,675441,1007266,768155,164235,973696,515273,718800,456237,231527,252964,372477,299284,658426,558799) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50625 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50625 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004104s ]