SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5075 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5075 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (565080,726420,286441,694453,17855,533116,323077,866058,425016,547938,568647,773900,758248,274842,640590,259611,245212,975663,573583,194362,330904,699158,105492,654300,172112,995244,391978,667506,470395,495906,890523,941109,470341,480046,1042630,598461,369650,382144,483514,943794,425302,726497,615792,480420,201593,913062,73837,476588,1043959,263973,1030685,1035752,174692,447871,354997,616127,560076,590609,591510,845032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5075 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5075 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]