SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043508 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043508 [ RunTime:0.002757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835943,650826,126239,869694,952479,894312,870292,770370,70307,886164,721444,497780,427637,519430,607432,41517,670658,136582,1032640,101581,961400,454973,419670,977190,973524,504653,974678,875592,332023,39013,584914,872091,471433,288935,78829,674368,294045,157436,934339,895762,458984,724782,571800,551521,711642,985740,710517,255733,406931,279337,1041204,955512,896187,597684,819928,260882,662375,475355,2517,682157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]