SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504668 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504668 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793935,12553,889668,50224,127016,691972,234806,1041342,168248,570596,911663,525981,812673,672032,855218,850145,431406,859802,327541,205603,578246,144051,1002554,985911,357361,688002,35205,498240,501745,393371,445576,745593,969483,24405,616080,681523,403228,419944,132454,230592,601622,816510,1005083,732253,445962,543773,351741,966358,755682,1022117,921363,192143,299649,465325,358280,630273,898940,516038,909405,731050) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]