SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023398 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023398 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680258,78493,34114,77100,470249,129946,375416,258112,256242,477738,614392,250717,848773,404896,613806,786048,686031,846869,922695,580597,188552,11473,969471,99293,290118,853572,337004,650312,747761,906274,579789,910366,895485,453382,681020,735583,536512,670341,536567,987633,686796,164075,572462,896513,351111,623664,776685,264890,898144,984642,455077,869203,716456,210045,950707,32406,454171,941372,313870,957406) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]