SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001041s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981712 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981712 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (279970,197126,966148,340992,438168,356654,83135,396714,569757,143713,1005783,769194,485515,890146,908562,511688,259865,196400,919303,127731,523804,128723,890028,675851,584587,567610,824143,157090,18926,894940,843340,634946,195902,733470,471303,267674,285719,429558,120074,405518,393986,130266,865401,722448,1014050,471362,679950,852270,1032940,235048,927841,238996,555117,448415,135812,360778,909409,287460,377016,515850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]