SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002116s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 512056 LIMIT 1 [ RunTime:0.002762s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 512056 [ RunTime:0.004509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (917636,917563,505732,505681,334786,159918,1032364,185996,5279,211503,764717,1004747,126294,449649,637881,178464,475163,344070,1000292,264155,887002,137531,25783,368998,523186,376810,775912,393124,1034384,218926,950166,822503,401268,245257,635529,923750,231614,432226,70003,437704,332289,789886,12517,1037856,220993,817983,176685,1034778,561631,740572,163695,547217,100763,321338,825289,85234,843,734762,754618,881130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 512056 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 512056 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001869s ]