SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 143804 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 143804 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (301257,352293,1045467,701426,209975,26452,692650,567937,574957,1020074,664722,455265,501410,325430,749686,481209,428643,300846,548552,868493,272763,265833,484872,466188,245539,109235,540941,37207,625747,726699,917116,303940,510655,573604,240876,256747,527667,822113,388299,660097,592072,23280,843130,797009,755498,852657,458837,178985,329135,397639,771182,68914,363772,97027,900039,393351,165135,731684,652057,452947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 143804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 143804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]