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` = 109450 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109450 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (782257,668491,1013798,303932,104582,443024,538452,786960,70700,523681,981424,845346,872938,357164,912832,693893,293873,218146,334120,852806,887297,110016,239195,276167,223654,482920,749365,335095,217898,480097,823198,72961,982877,317999,452908,951910,5206,666075,484875,237711,591658,522403,54891,827260,830446,782986,955373,225779,93846,409990,998637,368637,383016,1013305,252623,254594,1048317,836693,737504,690186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000698s ]