SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424029 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424029 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (527084,8386,645549,580337,780252,116697,412865,822509,900077,850173,731768,294707,621373,131317,1022388,286998,1004108,571750,627068,1012940,885138,281004,260653,194893,264083,648011,762483,389324,610500,203716,998082,918262,458379,901471,618006,96357,319114,525015,865424,218159,483848,675838,131871,711666,839120,181633,985982,158645,67726,918075,688057,575829,451566,470895,463583,626222,896934,91315,971082,740484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]