SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005460 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005460 [ RunTime:0.001955s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (102521,520752,689289,387639,113665,684070,45311,50405,135227,1023402,209224,755225,263218,932590,366325,509026,57698,32479,931621,169246,96826,216322,246817,520611,767427,577827,281065,756588,232673,369628,534110,806545,336642,329152,916788,399810,322352,608517,983098,1013487,211064,995519,187847,843600,840771,289005,540085,445883,283057,774755,352208,987714,565759,699403,204351,844214,820684,717403,229547,486318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]