SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502963 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502963 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838533,390992,247715,218940,794611,1022107,674148,769494,611102,653548,874307,588549,476014,178101,404311,248208,582067,29520,223377,723876,204405,104277,589211,542336,325550,531719,391870,966739,611112,283622,791420,776534,708461,174413,267375,934786,590483,341280,449251,173011,940632,192791,313489,540966,56169,394345,131498,536824,101340,164446,344690,942848,1025060,927451,194083,737386,250532,90521,911713,389129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000983s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]