SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.007750s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460596 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460596 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194185,348706,4638,107222,968308,259937,794310,380963,127755,500884,947192,328666,421671,860221,379809,916575,125462,1037031,261449,921834,797800,809674,226608,32003,759007,772127,267850,1040633,78602,293491,765956,98679,284306,219478,344564,377758,417925,244965,896535,1029205,697827,699383,723759,6293,308710,697532,294680,528751,711239,824676,294209,421697,747114,37121,896467,673895,1009616,593236,1032778,63704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460596 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460596 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001679s ]