SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 393710 LIMIT 1 [ RunTime:0.002210s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 393710 [ RunTime:0.003016s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872069,896590,651056,814010,1039166,768684,886423,286833,368082,724087,797535,328138,915813,740998,400570,269851,75236,239177,982076,561609,447098,23688,796126,406049,233736,121534,510348,36710,1007691,424669,834278,218818,349703,177051,615074,114438,518911,605186,1045288,177789,191754,159459,132258,736981,696774,704738,80769,515232,244627,379744,814284,935131,467628,228861,376331,869328,547675,155818,351837,860883) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 393710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 393710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000643s ]