SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501213 LIMIT 1 [ RunTime:0.001087s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501213 [ RunTime:0.002108s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (807948,309539,534935,314342,559555,539377,920790,968152,489483,401604,722722,439086,303943,760957,180235,166002,955850,521089,994755,30579,451682,183715,350510,528917,840157,381482,546659,174346,243935,906982,23407,551163,826806,926507,306317,777046,303006,650455,582647,207545,501704,47869,957682,363933,719365,584905,814565,19968,31125,217882,677168,22570,63253,683401,554866,56609,447940,137870,661785,977216) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001629s ]