SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029062 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029062 [ RunTime:0.002701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258238,288414,131834,439217,103515,1000114,847905,773445,586839,182159,901547,676473,1013134,825698,303051,212969,260315,892451,420821,969103,397512,903711,845615,662204,943255,1014121,747095,249747,107782,261034,592192,338045,434739,672956,1009185,908831,500785,341582,714533,632333,587377,815589,954190,626122,713636,474151,4948,90336,1014635,68898,743088,972309,441406,444197,18528,1016244,964078,74550,762272,262542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029062 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029062 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]