SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421960 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421960 [ RunTime:0.003479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511105,988786,595604,979640,875801,547850,452259,815594,423289,382621,125530,374991,248913,300449,660760,933345,277313,356750,897492,833653,306915,115450,972584,462256,75849,217779,243746,1016156,730171,31845,819853,1022611,177838,848781,84404,1008518,960228,1007507,962413,706355,735942,943286,370200,955587,444481,317226,547609,929012,322090,216851,428267,682017,706050,798269,710271,587193,318356,136461,713088,272548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421960 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421960 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]