SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504369 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504369 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482774,180659,92306,1000201,352006,805951,26815,35164,30400,817015,366234,545811,860690,678776,228572,380823,38668,936589,811385,230087,731064,785302,662448,364536,244862,972097,578882,353995,548235,225936,708945,614635,10001,483317,940394,823991,53422,66078,550040,212778,525854,617688,70485,192535,627752,365728,1894,516349,864609,961570,835476,957117,947275,737736,27982,95907,846939,100876,96395,152795) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504369 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504369 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]