SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50701 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50701 [ RunTime:0.003735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547154,381270,890233,507132,92116,133298,538945,92736,774439,733989,15205,651002,486004,111035,832583,463597,596114,151555,1008517,906296,723213,326648,885260,231368,710562,980307,1035698,574468,556653,794153,531324,935280,441144,528290,390489,462368,545877,661789,555963,952584,82215,727591,538858,680188,22618,408668,893790,626871,916297,351575,938080,292449,199539,279244,439493,220579,956531,609430,117902,315985) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001706s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]