SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50626 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50626 [ RunTime:0.001996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259673,667945,73445,805827,549278,520548,675391,541677,299386,871143,204459,290666,794413,489833,377842,303450,23791,160324,97304,834785,83806,1020753,205870,358019,443773,522484,59195,536393,349075,812280,418308,594620,207873,265329,332163,803561,160254,448042,702343,749428,33994,814462,589702,351,371004,611148,628464,809507,32135,760009,419436,106276,368978,152521,252354,39900,388830,819459,759355,150831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]