SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 262626 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 262626 [ RunTime:0.002756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12436,836820,388772,161653,33609,488664,788608,779214,681882,133688,710784,729558,987107,274145,50975,432398,60399,1020526,193157,320569,806224,180990,731413,886316,171454,784341,914853,743915,230445,715721,354484,266223,1010166,13513,712360,32704,891750,86652,176819,498300,36799,584302,717157,656431,45862,427389,788456,498006,350968,620865,959640,410625,505613,778669,968951,883059,865779,416421,315498,569265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 262626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 262626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]