SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005680s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526413 LIMIT 1 [ RunTime:0.003573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526413 [ RunTime:0.006311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453772,184423,730750,971050,935045,285445,183022,856261,125309,291821,80424,637620,963639,889320,18959,754817,654224,449429,177482,95685,1009397,174657,970272,907829,144598,524011,191422,581790,550779,926974,180790,437278,432142,456532,240857,545587,1308,356916,575680,938840,641805,349635,918479,716437,993319,152783,816104,369030,937027,101130,759264,325585,294906,240578,156844,434956,608844,70737,522575,630856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.008160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]