SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399510 LIMIT 1 [ RunTime:0.000580s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399510 [ RunTime:0.005118s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753434,621624,75398,230370,766624,672771,1046563,666236,883072,791795,512643,262882,765296,14213,819540,601903,885254,858288,814051,322707,579645,490827,27727,656925,741359,950188,442230,89933,673978,610375,259489,52288,962642,606571,1000783,280854,191112,302252,748758,875175,283092,891772,105684,185483,842481,211767,362432,990339,259685,639274,849117,791937,338753,189947,135588,242859,780012,421404,161617,637158) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]