SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531247 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531247 [ RunTime:0.001746s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (871129,316523,216596,152159,340056,842187,461564,788830,48265,503923,349788,410855,676156,656860,213601,22322,1040880,259231,116152,785005,787762,644144,719057,824031,390203,893030,491399,131430,198727,507930,431743,434846,812355,393333,634440,417787,1032405,439816,983024,45381,797255,718076,322254,309058,603939,532016,274094,995532,264414,443918,253982,367403,759689,992503,151160,730562,973630,273388,648895,925750) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]