SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 803391 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 803391 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187303,875779,587263,71943,189947,425656,484085,593082,212836,429075,141975,56776,444187,123289,295198,910172,922005,843057,906207,71914,806632,1013455,688126,125698,902438,378510,566558,949678,792778,722467,934984,368348,328619,359653,569981,777351,138999,300827,566274,143859,708647,684485,1029284,467846,529820,906728,531213,1013375,551952,945397,412056,698216,977944,1033282,955375,681771,123030,102368,301677,475811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 803391 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 803391 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]