SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001966s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 992012 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 992012 [ RunTime:0.001709s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477714,878428,272776,796331,89529,431085,298509,38437,455665,460784,759961,221675,696614,803407,295859,1028543,328674,278871,20721,174135,201727,748636,721646,708260,756675,968474,171521,557164,474080,31206,604863,949624,319728,736507,636525,14719,799430,146856,344940,980443,1005149,872721,179645,814836,963422,792833,647790,170589,815560,614776,363715,769208,420702,450416,722901,709426,109341,1030507,101666,598586) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003166s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 992012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 992012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]