SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201160 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201160 [ RunTime:0.001385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463397,232217,1011756,530867,605675,719601,372508,999577,670212,548328,599985,283335,305245,383833,371038,734265,563344,798216,947708,697143,46935,910905,329645,100562,838177,279811,1020725,767588,799616,934484,418819,107627,835029,883209,742654,603301,740195,604648,789726,541738,782912,992874,25140,736195,238873,731086,1013094,332805,616792,898277,724784,1009015,770905,214200,93726,580782,377320,260951,948759,1011715) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]