SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020734 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020734 [ RunTime:0.002007s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580406,919505,1030034,125288,918231,869948,673242,722945,1025809,159146,392335,356983,68333,88240,888387,484818,694343,674610,478120,353998,670460,658715,135920,269952,1021603,848128,1025416,32749,703191,624192,211580,306619,1042802,423428,13460,821159,371666,98069,241556,266834,576312,149499,931000,804478,739288,55797,118805,328596,971288,665528,821946,764581,15001,600677,755901,647717,236036,60248,90828,222431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020734 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020734 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]