SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456193 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456193 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260813,272004,984506,1026547,92941,925074,36894,932514,632366,759490,94372,43836,48300,1008780,605589,548670,955876,654885,876725,743816,321589,997755,196967,647254,50754,210109,341443,733599,1037432,68210,1031429,281074,973736,38763,690538,471202,62592,803975,680129,205796,905318,542916,218827,470177,497542,72471,868928,934237,762176,494548,911418,245843,639106,494127,270597,606210,677321,483189,418041,784483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456193 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456193 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]