SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548318 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548318 [ RunTime:0.001716s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393014,336623,390225,130290,964825,295154,838004,314630,375445,379397,66430,908790,704766,290318,885608,247104,333901,853912,333183,364081,812975,991078,864641,438513,182940,412920,516599,34159,144665,232430,641642,217744,587270,932449,197674,992466,158237,352268,189954,89490,34310,655880,915390,238897,129276,130160,410770,253267,687435,122236,430695,350241,17711,722829,1010482,829927,670985,25239,507171,205459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]