SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541604 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541604 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313141,112770,522832,844046,641090,323501,308483,109714,376525,394777,552699,360338,16211,696653,78733,387760,761393,76547,77176,348243,759332,731454,235767,295268,121790,997678,585856,888575,70503,519896,547415,256572,430188,369771,724667,117087,108427,216215,879367,778551,834075,262968,149106,1017037,468518,510121,144434,1037722,894074,338284,901987,1025400,283194,76104,773192,12660,739074,57370,151517,179319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000892s ]