SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454504 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454504 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (607105,74153,188043,774432,4243,481813,720505,924110,537595,36961,387463,946628,68567,496653,711998,1031190,903618,331309,523042,837363,297774,541708,148243,205422,535699,977748,171204,912613,852540,1006714,704614,449160,577113,849856,440081,215941,119696,451468,743703,541987,595739,369656,136157,933824,17990,1026617,814224,250047,208127,877406,467286,861677,167403,412049,339513,676637,947816,238689,703585,421837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]