SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351097 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351097 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698047,675593,350102,806017,633539,1039999,426531,575070,10458,497548,779477,820600,917834,288979,65691,109211,849943,734638,211454,402841,430306,314505,876835,1003715,932632,335284,751222,553889,307072,690476,317685,855572,172622,125957,505377,900977,641252,1024670,324478,381309,104378,725835,908156,19595,736237,272422,842203,762042,679087,596154,863334,495981,291299,630389,578054,413486,168318,537568,834279,800788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]