SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002010s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047110 LIMIT 1 [ RunTime:0.001808s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047110 [ RunTime:0.004151s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (487157,968925,708502,379696,293140,379532,591110,225230,400932,867564,490899,994848,958329,292671,539288,146066,935452,234067,124908,299051,187045,502956,662496,221618,228095,524550,764628,468685,104665,710048,1036570,975900,776062,747208,693177,615121,532801,917440,294876,606520,270017,671995,953233,165119,1036432,789246,396472,281954,640220,259925,332327,1016053,481217,342569,702050,556392,208602,220926,687984,41782) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000800s ]