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` = 1040893 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040893 [ RunTime:0.005405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451606,710652,360502,936188,123486,721176,290493,139199,12001,883301,180145,909824,56026,490168,357138,436539,687202,432343,845723,963818,608214,489324,842835,470910,946181,257417,453705,921902,760359,454576,192190,1026107,469757,458463,165659,825855,140592,129678,866430,290987,947785,526162,921619,69427,482128,691507,345265,252875,730912,349209,294444,726678,269457,604869,992292,194249,962378,516893,359519,494695) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040893 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040893 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]