SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343651 LIMIT 1 [ RunTime:0.000554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343651 [ RunTime:0.005586s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (525947,1007567,655808,967406,848951,161918,536763,640421,185585,235686,326614,343106,440611,836711,576822,120100,390847,801442,958888,634749,41169,995755,826567,983629,887056,864492,557897,393759,405747,82012,714834,896807,972393,152710,62241,454036,659071,868601,528656,506627,601794,671534,499138,811421,778898,616793,554524,880555,184965,115254,1030599,949117,380160,726513,645446,557430,489942,406647,998956,584143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343651 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343651 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]