SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297004 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297004 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (763925,268353,488814,908760,137097,123878,441905,584085,205387,154482,344465,864857,39139,53176,121441,453940,145478,176452,916392,409809,331205,937209,14496,346664,902332,812116,10076,371157,2039,791543,633350,212897,130476,544735,987066,655133,337510,472382,1002478,450730,707415,891829,364972,663479,236387,439258,593297,315163,20787,535650,842040,616452,74130,810089,82477,804111,1024807,1003428,576586,276058) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]