SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001608s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141580 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141580 [ RunTime:0.002115s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300782,211694,135339,576053,441388,959269,226608,1021248,91404,401331,832089,102448,114365,996,250907,182352,190589,594146,975385,810315,478014,927008,10615,898801,1040778,670875,26504,908157,920967,701918,579188,767222,308574,735302,72620,577658,201091,86324,674554,849783,458218,401991,634441,184296,750863,124853,104512,792828,426696,103976,452201,880159,738459,743907,599775,390255,342725,123502,238872,22505) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001063s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]