SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394829 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394829 [ RunTime:0.001473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474642,567815,839856,102838,903030,252419,488354,984311,71859,563679,773377,805324,961658,56316,14274,493069,815155,327025,83914,324056,722940,791526,228144,831176,653746,685423,749962,59491,577266,171151,1039487,221264,696887,876413,268126,1044657,53914,464045,578159,3017,370956,504822,980881,790151,422327,821310,791733,880095,509644,690757,837033,636993,28623,583560,1032137,65478,356991,704336,447627,960724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]