SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 916312 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 916312 [ RunTime:0.001471s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672574,773079,573977,648772,270896,912481,884805,402572,866774,223891,904580,119393,298329,509124,665265,492880,575947,428843,1031062,116541,868357,432864,224405,382130,51588,1041151,300695,590773,286426,529162,240465,132855,465213,633771,780713,532138,899738,535480,989943,758747,331769,685108,80125,321773,566050,603052,166947,371265,640321,173090,334343,473221,955382,698630,417184,582921,813134,515418,328461,231263) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 916312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 916312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]