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` = 539954 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539954 [ RunTime:0.002166s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (304327,959307,126684,881360,633963,317420,48028,121648,835111,798818,17792,752086,994731,117886,5733,581317,560655,1018411,878662,773485,988034,572756,219002,243694,678688,501138,220570,358600,836321,59470,466477,222978,327421,384528,662644,448078,666851,57262,747132,508892,140440,992924,152868,47657,154549,403768,853276,479741,700989,998382,431932,566840,229806,1013814,544789,146361,112703,565074,818692,862627) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]