SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002880s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416406 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416406 [ RunTime:0.003649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558130,796890,1004732,804858,399340,541551,587722,60224,43213,405014,854271,849805,406004,955760,96612,184661,863454,652854,363436,651911,924576,694905,558543,653734,128811,576817,1016855,109057,631624,207807,186372,565002,699194,230240,1035098,311450,68674,963691,561087,386217,213845,262669,861858,14380,294254,580909,881934,883157,439759,175080,441872,308344,394758,42323,47949,276005,731661,870083,16176,804085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000456s ]