SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311033 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311033 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (933194,863480,512167,337600,508104,523834,875748,605817,5692,7001,836584,333622,453670,443623,185001,722299,454890,823454,35821,334372,492288,10365,662179,975275,854100,412685,357284,227485,828923,272531,786033,745896,593005,1001679,899092,770591,55794,939666,637806,1017480,511304,583556,573973,867934,987745,954559,129688,846269,866587,365862,651215,276723,806795,1025471,993065,84736,119787,86664,936247,845721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311033 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311033 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]