SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001240s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499564 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499564 [ RunTime:0.004120s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (724929,422030,739163,492902,985444,543542,3866,644071,842947,897743,242807,897820,224711,458943,376703,732752,615440,64982,852511,360076,178004,972926,179559,264415,309280,980082,870250,556578,263778,969775,251690,107522,84567,411019,515033,865480,545325,8656,746437,1013596,234863,89430,467880,466077,114890,52551,115646,923888,488260,734428,964745,794006,255273,162819,236857,891854,995058,872835,899441,848382) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]