SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536528 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536528 [ RunTime:0.001654s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (726827,724332,946714,717857,214467,300612,325534,757479,637283,410308,137174,597783,147291,154935,269669,273705,926635,742154,150828,668715,574138,697938,1010716,732973,856430,1021745,1010262,489817,48178,45570,290113,314571,28315,400844,875260,551017,1002870,617760,999544,435833,285696,35626,337090,675947,573984,908664,416657,624873,362509,180313,180010,42245,358533,130776,799900,719894,243392,352683,268467,801950) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]