SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440812 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440812 [ RunTime:0.002673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235101,360867,787657,507033,1011426,855492,956444,33784,736091,582635,127316,742946,1002688,668221,411752,39374,991685,784388,213912,439011,449946,954660,861656,734226,464063,184627,365058,397845,837989,383452,112463,66732,743506,238921,247997,301984,302810,737940,438802,340671,345810,1030323,252699,406164,1028266,661057,733710,628010,578393,104306,96265,1026344,640038,686346,412159,161823,665757,1000525,788387,633390) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]