SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197453 LIMIT 1 [ RunTime:0.003455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197453 [ RunTime:0.004985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368022,10812,475009,33977,669360,477026,797723,569264,86792,587711,281814,212434,476140,376020,179692,468045,955159,499348,714040,30134,779001,125932,626367,168310,1044968,258100,202543,600981,823117,351821,738396,1046871,998149,455026,488700,541100,403085,784426,450384,601672,365166,619045,737738,356676,643466,206603,890014,482071,280489,835863,145727,547688,624636,627563,71863,511916,228427,751717,632875,374468) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]