SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419715 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419715 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (990026,251071,334904,400112,580703,94927,490930,45721,887623,711729,995090,159986,1002342,297471,588421,989161,641345,980604,352752,1026007,1011648,689304,145129,912357,875318,272453,520839,154647,670668,583635,245,502974,337410,225677,815818,136792,623743,671675,393309,551997,927784,802134,472474,756890,746805,338595,123031,811606,954768,511636,253842,539176,351806,672785,115685,912724,285985,358372,148298,746863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419715 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419715 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]